class CreateCharacters < ActiveRecord::Migration
  def self.up
    create_table :characters do |t|
      t.integer :player_id
      t.integer :partner_id
      t.integer :father
      t.integer :mother
      t.string :christian_name
      t.string :family_name
      t.integer :culture_id
      t.integer :honour
      t.integer :prestige
      t.integer :piety
      t.integer :wealth
      t.string :sex
      t.integer :dob
      t.string :marital_status
      t.integer :diplomacy
      t.integer :martial
      t.integer :stewardship
      t.integer :intrigue
      t.integer :loyalty
      t.integer :fertility
      t.integer :health

      t.timestamps
    end
  end

  def self.down
    drop_table :characters
  end
end
